CONNECT BY WITH FILTERING
Short Description
CONNECT BY describes how LEVELs are created within hierarchical queries
Detailed Description
CONNECT BY describes how LEVELs are created within hierarchical queries. A hierarchical query needs a definition of how child and parent records are related, this is provided by the CONNECT BY .. PRIOR syntax.
The WITH FILTERING node applies the filtering defined within the CONNECT BY clauses, rather that the WHERE clause.
Additional Links
- Tim Hall’s Oracle Base viedo clip - Hierarchical Queries in Oracle
- Oracle SQL Ref - Hierarchical Queries
- Oracle Magazine - How to read an execution plan
- Oracle Tuning Guide - Explaining and Displaying Execution Plans
- Oracle Tuning Guide - Comparing Execution Plans Tutorial
Search online
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.